<<<<<<< HEAD
package com.wyz.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.wyz.vo.CourseTableVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author wk
 * @desc
 * @date 2024/12/25 14:54
 */
@Mapper
public interface CourseTableVOMapper extends BaseMapper<CourseTableVO> {
    @Select("select t_coursetable.coursetable_id,t_score.score_id,t_student.student_id,student_name,t_course.course_id,course_name,course_teacher,course_credit,score from t_student join t_coursetable on t_student.student_id=t_coursetable.student_id join t_course on t_coursetable.course_id=t_course.course_id join t_score on t_coursetable.coursetable_id=t_score.coursetable_id" )
    List<CourseTableVO> queryAllCourseTable();
    @Select("select t_coursetable.coursetable_id,t_score.score_id,t_student.student_id,student_name,t_course.course_id,course_name,course_teacher,course_credit,score from t_student join t_coursetable on t_student.student_id=t_coursetable.student_id join t_course on t_coursetable.course_id=t_course.course_id join t_score on t_coursetable.coursetable_id=t_score.coursetable_id where t_coursetable.student_id=#{studentId}")
    List<CourseTableVO> queryCourseTableByStudentId(Integer studentId);
}

=======
package com.wyz.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.wyz.vo.CourseTableVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author wk
 * @desc
 * @date 2024/12/25 14:54
 */
@Mapper
public interface CourseTableVOMapper extends BaseMapper<CourseTableVO> {
    @Select("select coursetable_id,t_student.student_id,student_name,t_course.course_id,course_name,course_teacher,course_credit from t_student join t_coursetable on t_student.student_id=t_coursetable.student_id join t_course on t_coursetable.course_id=t_course.course_id" )
    List<CourseTableVO> queryAllCourseTable();
}
>>>>>>> be516e15a35375b38cf973b1ce88c92dd1ceba03
